Re: Intermittent Connection (DB2 Agent on System i)

Notes/Domino 8 Forum

Subject:

Hi Michael!

Since you're using an ODBC Connection within an Agent, I would suggest you review the JobLogs of the AMGR Jobs after the Agent completes execution for the SQL errors mentioned by Gil.

However, you may want to consider trying LSX:LC instead of LS:DO (i.e. ODBC) as LS:DO is now considered "legacy". I have several information resources on using LSX:LC including connectivity with DB2 resources below for your reference:

1- Chapter 9 section 6 of this Redbook: http://www.redbooks.ibm.com/abstracts/sg246067.html?Open

2- See some LSX:LC samples in this Redbook: http://w3.itso.ibm.com/abstracts/redp0115.html?Open

3- Go through the sample LSXLC ( do not look at the LS:DO this is legacy only )
http://publib-b.boulder.ibm.com/Redbooks.nsf/3c7330a3359c75a68525698b007bbec9/e4de4d3f6bbbac7885256a020083336c?OpenDocument
It covers DB2 connector but the principal is the same for Oracle or other Relational Database.
You need to change the variables for the connection and the connector name as the argument is you have a different back end.

4- Read the following white paper on calling stored procedures
http://www-128.ibm.com/developerworks/lotus/library/db2-procedures/index.html

5- In addition the help files: ( these are installed in the users help directory)
Lotus Connector LotusScript Extensions Guide - http://www-12.lotus.com/ldd/doc/lei/6.5/lsxlc6.nsf

6- Lotus Connector and Connectivity Guide - http://www-12.lotus.com/ldd/doc/lei/651/lccon6.nsf

7- The sandbox presentation on LSX
http://www-10.lotus.com/ldd/sandbox.nsf/Search?SearchView&Query=ad208&SearchOrder=1&SearchMax=0&SearchWV=FALSE&SearchFuzzy=FALSE&Start=1&Count=10

Feedback response number ETEC7KEHAV created by ~Fritz Churether on 10/14/2008

Return to top

Intermittent Connection (DB2 Agent ... (~Sanjay Umtumis... 9.Oct.08)

. . Re: Intermittent Connection (DB2 Ag... (~Patti Nonniste... 10.Oct.08)

. . . . Re: Intermittent Connection (DB2 Ag... (~Sanjay Umtumis... 11.Oct.08)

. . . .

Re: Intermittent Connection (DB2 Ag... (~Holly Lopfooko... 14.Oct.08)

. . . . . . . . LS:DO (ODBCCOnnection) to LSX (DB2)... (~Sanjay Umtumis... 23.Oct.08)

. . . . . . . . . . Error occurred in SQL call level in... (~Sanjay Umtumis... 23.Oct.08)

. . . . . . . . . . . . Server restart & LS:DO problem (~Sanjay Umtumis... 23.Oct.08)

. . . . . . . . . . . . . . Re: Server restart & LS:DO problem (~Holly Lopfooko... 31.Oct.08)

. . LS:DO 8.0.1 to 8.0.2 (~Carol Lopachek... 10.Nov.08)

. . . . Failed Again (~Carol Lopachek... 18.Nov.08)

. . 8.0.2 ODBC Intermittent Connection ... (~Carol Lopachek... 18.Dec.08)

Printer-friendly

Search this forum

Member Tools

RSS Feeds

RSS feeds

	All forum posts RSS
	All main topics RSS